create external table jms_dm.dm_network_bagging_user_cnt_dt
(    date_time date comment '日期'
    , virt_code     string comment'虚拟代理区code'
    , virt_name     string comment'虚拟代理区name'
    , agent_code    string comment'代理区编码'
    , agent_name    string comment'代理区名称'
    , fran_code     string comment'加盟商编码'
    , fran_name     string comment'加盟商名称'
    , provider_id   string comment'省份ID'
    , provider_desc string comment'省份'
    , city_id       string comment'城市ID'
    , city_desc     string comment'城市'
    , area_id       string comment'区/县id'
    , area_desc     string comment'区/县'
    , network_code  string comment'编号'
    , network_name   string comment'名称'
    , bag_user_code  string comment'建包扫描人code'
    , bag_user_name  string comment'建包扫描人name'
    , bagging_qty      int comment'已建包票数'
    , package_qty      int comment'建包数(包号去重)'
    , net_bagging_qty  int comment'总网点票数'
)comment '建包扫描人效'
PARTITIONED BY ( dt string COMMENT '时间分区')
stored as parquet
LOCATION '/dw/hive/jms_dm.db/external/dm_network_bagging_user_cnt_dt'
TBLPROPERTIES (     'discover.partitions' = 'false',  'parquet.column.index.access' = 'true');
----------------------------------------------------------------